Search results 60

  2. Search results
  3. active year
Card image cap
RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

Jan25
Card image cap
PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

Jan22
Card image cap
CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

Jan1
Card image cap
ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

2023Dec23
Card image cap
ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22
Card image cap
ChartLegendCenter

Put chart legend at center of chart horizontally. Changes left and width only. ...

2023Dec21
Card image cap
SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

2023Nov29
Card image cap
Latest records date and count

Find how many items in table, with column DateAdded is the latest DateAdded in ...

2023Nov2
Card image cap
BusinessDateDiff

Number of Business days between two dates. Note that it doesn't take Christmas, ...

2023Oct25
Card image cap
ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13
Card image cap
CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10
Card image cap
ANmaHTMLContent

Reads certain part in HTML output of a page. Will search for list of strings ...

2023Jul1